SQL Tutorial Home

How to Add a Default Value to a Column in MySQL

In order to add a default value in MySQL, you need to use the alter table with the set default clause:

alter table employee alter last_bonus_date set default (current_date);